SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_PublicUserSearchEmployer]
    (
      @JOL_Employer_Name VARCHAR(50)
    )
AS 
    SELECT  JOL_Employer_Account,
            JOL_Employer_Name,
            JOL_Employer_Industry,
            JOL_Employer_Type,
            JOL_Employer_VerifyStatus
    FROM    dbo.JOL_Employer
    WHERE   JOL_Employer_Name LIKE '%' + @JOL_Employer_Name + '%'
    ORDER BY JOL_Employer_VerifyStatus DESC,
            JOL_Employer_AddTime DESC,
            JOL_Employer_UpdateTime DESC
GO
